<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body bgcolor="00ccff" text="#000000">
<%@ page import ="java.sql.*"%>
<%
       Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
 	Connection con=DriverManager.getConnection("jdbc:odbc:psi","psi","psi");
 	Statement st=con.createStatement();
 	ResultSet rs=st.executeQuery("select * from employee"); 	
 %>
<div align="center"> 
  <h2><font face="Arial, Helvetica, sans-serif" color="#993300">Employee Report</font> 
  </h2>
  <p align="center">&nbsp;</p>
  <p align="center">&nbsp; </p>
  <form name="form1" method="post" action="">
    <p>&nbsp;</p>
    <table width="75%" border="1">
      <tr> 
        <td>EmpCode</td>
        <td>EmpName</td>
        <td>ProjectCode</td>
        <td>Activity</td>
        <td>GroupCode</td>
      </tr>
      <%while(rs.next()){%>
      <tr> 
        <td>&nbsp;<%=rs.getString(1)%></td>
        <td>&nbsp;<%=rs.getString(2)%></td>
                <td>&nbsp;<%=rs.getString(5)%></td>
        <td>&nbsp;<%=rs.getString(6)%></td>
        <td>&nbsp;<%=rs.getString(7)%></td>
      </tr> 
      <%}%>
    </table>
    <p>&nbsp; </p>
  </form>
  <h2 align="left">&nbsp;</h2>
  <h2 align="left">&nbsp; </h2>
</div>
</body>
</html>
